library(readr)
## Warning: package 'readr' was built under R version 3.6.2
X<-read_table("https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt",col_names = FALSE)
##
## ── Column specification ───────────────────────────────────────────────────
## cols(
## .default = col_character()
## )
## ℹ Use `spec()` for the full column specifications.
## Warning: 12806 parsing failures.
## row col expected actual file
## 2 -- 21 columns 20 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
## 4 -- 21 columns 22 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
## 5 -- 21 columns 16 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
## 6 -- 21 columns 16 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
## 7 -- 21 columns 20 columns 'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'
## ... ... .......... .......... ...................................................
## See problems(...) for more details.
X
str(X)
## Classes 'spec_tbl_df', 'tbl_df', 'tbl' and 'data.frame': 16155 obs. of 21 variables:
## $ X1 : chr "01400000000000S7021610400700905300000PERDIDO" "01400000000000S7031610400300905303004PERDIDO" "0140000000000M00221810000000011319000UCHEE" "0140000008830399001410008800205900000LITTLE" ...
## $ X2 : chr "CREEK" "CREEK" "CREEK" "BEAR" ...
## $ X3 : chr "IRR" "IRR" "101ST" "CR." ...
## $ X4 : chr "BIA" "BIA" "AIRBORNE" "DAM" ...
## $ X5 : chr "RTE" "RTE" "RD" "SPW" ...
## $ X6 : chr "4007" "4003" "3.4" "CO." ...
## $ X7 : chr "11.4KM" "ON" "KM" "RD" ...
## $ X8 : chr "NW" "LYNN" "S" "88" ...
## $ X9 : chr "OF" "MCGEE" "OF" "LITTLE" ...
## $ X10: chr "ATMORE," "ROAD" "SUNSHINE" "BEAR" ...
## $ X11: chr "AL" "999900011000000000000000310620200873408900033626209200202000001592019500650000111150000000000A15501000001000009"| __truncated__ "RD" "CR" ...
## $ X12: chr "999900015000000000000000310610940873413480033626209199902000000502019500970300111150000000000A15505000001000009"| __truncated__ "000000021924N" "999900000000" "DAM" ...
## $ X13: chr "000000021924N" "N" "0032174330-0845837.0183747409194202000003752017401040000001150000000000A151040000030000073001830004300060060073"| __truncated__ "999900000000" ...
## $ X14: chr "N" "N" "Y60N" "0034270600087581200016367670819740200000430201750116099011115N000000000A195050000050000086001400006550000000087"| __truncated__ ...
## $ X15: chr "N" "0000000000000000002019" "1017" "061824N" ...
## $ X16: chr "0000000000000000002019" "0" "0000010000010000022019" "N" ...
## $ X17: chr "0" "0N2" "0N2" "N" ...
## $ X18: chr "0N2" "0100002608010" "0000001100350" "0N2" ...
## $ X19: chr "0100002601010" "Y800020020390000Y62" "Y50004002039" "0000001000050" ...
## $ X20: chr "Y800005920390000Y62" "G70000013328" "Y74" "Y50006002037" ...
## $ X21: chr "G70000014550" NA "F50000038700" "Y67" ...
## - attr(*, "problems")=Classes 'tbl_df', 'tbl' and 'data.frame': 12806 obs. of 5 variables:
## ..$ row : int 2 4 5 6 7 8 9 10 12 13 ...
## ..$ col : chr NA NA NA NA ...
## ..$ expected: chr "21 columns" "21 columns" "21 columns" "21 columns" ...
## ..$ actual : chr "20 columns" "22 columns" "16 columns" "16 columns" ...
## ..$ file : chr "'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'" "'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'" "'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'" "'https://www.fhwa.dot.gov/bridge/nbi/2020/AL20.txt'" ...
## - attr(*, "spec")=
## .. cols(
## .. X1 = col_character(),
## .. X2 = col_character(),
## .. X3 = col_character(),
## .. X4 = col_character(),
## .. X5 = col_character(),
## .. X6 = col_character(),
## .. X7 = col_character(),
## .. X8 = col_character(),
## .. X9 = col_character(),
## .. X10 = col_character(),
## .. X11 = col_character(),
## .. X12 = col_character(),
## .. X13 = col_character(),
## .. X14 = col_character(),
## .. X15 = col_character(),
## .. X16 = col_character(),
## .. X17 = col_character(),
## .. X18 = col_character(),
## .. X19 = col_character(),
## .. X20 = col_character(),
## .. X21 = col_character()
## .. )